SaBillingMethodDetail_Proxy

EntityType | Independent
Logical Entity Name | SaBillingMethodDetail_Proxy
Default Table Name | SaBillingMethodDetail_Proxy
Logical Only | NO
Owner | dbo
Definition |
Note |

SaBillingMethodDetail_Proxy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
SaBillingMethodDetail_ProxyID |  | INTEGER | NO |
RecordID |  | INTEGER | YES |
SaBillingMethodID |  | INTEGER | YES |
OldLowRange |  | NUMERIC(7, 2) | YES |
NewLowRange |  | NUMERIC(7, 2) | YES |
OldHighRange |  | NUMERIC(7, 2) | YES |
NewHighRange |  | NUMERIC(7, 2) | YES |
OldCostPerUnit |  | NUMERIC(9, 2) | YES |
NewCostPerUnit |  | NUMERIC(9, 2) | YES |
OldUnitType |  | CHAR(1) | YES |
NewUnitType |  | CHAR(1) | YES |
OldFlatRate |  | NUMERIC(9, 2) | YES |
NewFlatRate |  | NUMERIC(9, 2) | YES |
OldOverUnit |  | NUMERIC(7, 2) | YES |
NewOverUnit |  | NUMERIC(7, 2) | YES |
OldSaBillCodeID |  | INTEGER | YES |
NewSaBillCodeID |  | INTEGER | YES |
OldSyCampusID |  | INTEGER | YES |
NewSyCampusID |  | INTEGER | YES |
OldAdCourseLevelID |  | INTEGER | YES |
NewAdCourseLevelID |  | INTEGER | YES |
OldIsAudit |  | BIT | YES |
NewIsAudit |  | BIT | YES |
OldEffectiveDateType |  | CHAR(1) | YES |
NewEffectiveDateType |  | CHAR(1) | YES |
OldEffectiveDate |  | DATETIME | YES |
NewEffectiveDate |  | DATETIME | YES |
Comment |  | VARCHAR(255) | YES |
UserId |  | INTEGER | YES |
ModFlag |  | CHAR(1) | YES |
DateAdded |  | DATETIME | NO |

SaBillingMethodDetail_Proxy Keys

Key Name | Key Type | Keys
SaBillingMethodDetail_Proxy_SaBillingMethodID_N_N_IDX | Inversion Entry | SaBillingMethodID
PK_SaBillingMethodDetail_Proxy_SaBillingMethodDetail_ProxyID | PrimaryKey | SaBillingMethodDetail_ProxyID

SaBillingMethodDetail_Proxy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
BillingMethodDetail | Non-Identifying | Zero or One to Zero or More |  |  |  | RecordID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

SaBillingMethodDetail_Proxy Check Constraints

Check Constraint Name | CheckConstraint

SaBillingMethodDetail_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SaBillingMethodDetail_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaBillingMethodDetail_Proxy | NO |  |  |

SaBillingMethodDetail_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaBillingMethodDetail_Proxy Data Movement Rules

Name | Type | Rule Text/Value